package com.sky.mapper;

import com.sky.entity.ShoppingCart;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @Author：chén jiā jùn
 * @Create：2023年11月19日23:30
 */
@Mapper
public interface ShoppingCartMapper {
	/**
	 * 条件查询
	 *
	 * @param shoppingCart
	 * @return
	 */
	List<ShoppingCart> list(ShoppingCart shoppingCart);

	/**
	 * 更新商品数量
	 *
	 * @param shoppingCart
	 */
	@Update("update shopping_cart set number = #{number} where id = #{id}")
	void updateNumberById(ShoppingCart shoppingCart);

	/**
	 * 插入购物车数据
	 *
	 * @param shoppingCart
	 */
	@Insert("insert into shopping_cart (name, user_id, dish_id, setmeal_id, dish_flavor, number, amount, image, create_time) " +
			" values (#{name},#{userId},#{dishId},#{setmealId},#{dishFlavor},#{number},#{amount},#{image},#{createTime})")
	void insert(ShoppingCart shoppingCart);

	/**
	 * 根据用户id删除购物车数据
	 *
	 * @param userId
	 */
	@Delete("delete from shopping_cart where user_id = #{userId}")
	void deleteByUserId(Long userId);

}
